RDBMS SOLUTION


ASSIGNMENT 4 

SET B Q. 2 SOLUTION

Write function which will return rate of “Harddisk” supplied by “Mr. Patil”.




Source code:

    

    /*set b q 2 solution*/

/*function*/

create or replace function get_rate(ino in out number,sno in out number)

return number is p_rate number;

begin

select itemno into ino from item i where item_name='Harddisk';

select supplierno into sno from supplier s where supplier_name='mr.Patil';

select rate into p_rate from i_s si where si.supplier_number=sno and si.item_number=ino;

return p_rate;

end;

/*Execution*/

declare

ino number;

sno number;

rate number;

begin

rate:=get_rate(ino,sno);

dbms_output.put_line('rate=  '||rate);

end;

/*point to be remembered: PL/SQL is a case sensetive language*/

/*source code in description*/
 Download code         next